﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Main.master" AutoEventWireup="true" CodeBehind="TraCuuDiemHocVien.aspx.cs" Inherits="WTSQCB.TraCuuDiemHocVien" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <p>
        Tra cứu điểm học tập</p>
    <p>
        Nhập mã số học viên:
        <asp:TextBox ID="MaHocVientxt" runat="server"></asp:TextBox>
&nbsp;&nbsp; <asp:Button ID="TraCuubtn" runat="server" OnClick="TraCuubtn_Click" Text="TRA CỨU" />
    &nbsp;Chọn học kì:
        <asp:DropDownList ID="HocKiddl" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="TenHocKi" DataValueField="MaHocKi">
        </asp:DropDownList>
&nbsp;&nbsp;
    </p>
    <p>
        Điểm môn học</p>
    <p>
        <asp:GridView ID="MonHocdgv" runat="server" AllowPaging="True" AutoGenerateColumns="False" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="MaHocVien,MaMonHoc" DataSourceID="SqlDataSource2" Width="980px">
            <Columns>
                <asp:BoundField DataField="MaHocVien" HeaderText="Mã Học Viên" ReadOnly="True" SortExpression="MaHocVien" />
                <asp:BoundField DataField="HoTen" HeaderText="Họ Tên" SortExpression="HoTen" />
                <asp:BoundField DataField="TenHocKi" HeaderText="Tên Học kì" SortExpression="TenHocKi" />
                <asp:BoundField DataField="MaMonHoc" HeaderText="Mã môn học" ReadOnly="True" SortExpression="MaMonHoc" />
                <asp:BoundField DataField="TenMonHoc" HeaderText="Tên môn học" SortExpression="TenMonHoc" />
                <asp:BoundField DataField="SoDVHT" HeaderText="Số DVHT" SortExpression="SoDVHT" />
                <asp:BoundField DataField="DiemQuaTrinh" HeaderText="Điểm quá trình" SortExpression="DiemQuaTrinh" />
                <asp:BoundField DataField="DiemThi" HeaderText="Điểm thi" SortExpression="DiemThi" />
                <asp:BoundField DataField="DiemKetThuc" HeaderText="Điểm kết thúc" SortExpression="DiemKetThuc" />
            </Columns>
            <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
            <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
            <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
            <RowStyle BackColor="White" ForeColor="#003399" />
            <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
            <SortedAscendingCellStyle BackColor="#EDF6F6" />
            <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
            <SortedDescendingCellStyle BackColor="#D6DFDF" />
            <SortedDescendingHeaderStyle BackColor="#002876" />
        </asp:GridView>
    </p>
    <p>
        Điểm học kì:</p>
    <p>
        <asp:GridView ID="HocKidgv" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="MaHocVien" DataSourceID="SqlDataSource3" Width="980px">
            <Columns>
                <asp:BoundField DataField="MaHocVien" HeaderText="Mã học viên" ReadOnly="True" SortExpression="MaHocVien" />
                <asp:BoundField DataField="HoTen" HeaderText="Họ tên" SortExpression="HoTen" />
                <asp:BoundField DataField="TenHocKi" HeaderText="Tên học kì" SortExpression="TenHocKi" />
                <asp:BoundField DataField="DiemTrungBinh" HeaderText="Điểm trung bình" ReadOnly="True" SortExpression="DiemTrungBinh" />
            </Columns>
            <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
            <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
            <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
            <RowStyle BackColor="White" ForeColor="#003399" />
            <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
            <SortedAscendingCellStyle BackColor="#EDF6F6" />
            <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
            <SortedDescendingCellStyle BackColor="#D6DFDF" />
            <SortedDescendingHeaderStyle BackColor="#002876" />
        </asp:GridView>
    </p>
    <p>
        Điểm toàn khóa:</p>
    <p>
        <asp:GridView ID="KhoaHocdgv" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="MaHocVien" DataSourceID="SqlDataSource4" Width="980px">
            <Columns>
                <asp:BoundField DataField="MaHocVien" HeaderText="Mã học viên" ReadOnly="True" SortExpression="MaHocVien" />
                <asp:BoundField DataField="HoTen" HeaderText="Họ tên" SortExpression="HoTen" />
                <asp:BoundField DataField="TenLop" HeaderText="Tên lớp" SortExpression="TenLop" />
                <asp:BoundField DataField="DiemTrungBinh" HeaderText="Điểm trung bình" ReadOnly="True" SortExpression="DiemTrungBinh" />
            </Columns>
            <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
            <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
            <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
            <RowStyle BackColor="White" ForeColor="#003399" />
            <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
            <SortedAscendingCellStyle BackColor="#EDF6F6" />
            <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
            <SortedDescendingCellStyle BackColor="#D6DFDF" />
            <SortedDescendingHeaderStyle BackColor="#002876" />
        </asp:GridView>
    </p>
    <p>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:WebDiemTSQCBConnectionString %>" SelectCommand="LocHocKiTheoHocVien" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:ControlParameter ControlID="MaHocVientxt" Name="mahocvien" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:WebDiemTSQCBConnectionString %>" SelectCommand="DiemTungMonHoc" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:ControlParameter ControlID="MaHocVientxt" Name="mahocvien" PropertyName="Text" Type="String" />
                <asp:ControlParameter ControlID="HocKiddl" Name="mahocki" PropertyName="SelectedValue" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:WebDiemTSQCBConnectionString %>" SelectCommand="DiemHocKi" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:ControlParameter ControlID="MaHocVientxt" Name="mahocvien" PropertyName="Text" Type="String" />
                <asp:ControlParameter ControlID="HocKiddl" Name="mahocki" PropertyName="SelectedValue" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p>
        <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:WebDiemTSQCBConnectionString %>" SelectCommand="DiemToanKhoa" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:ControlParameter ControlID="MaHocVientxt" Name="mahocvien" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
</asp:Content>
